{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Flat Bodies","Flex Face Dimensions"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":44,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Flat Bodies","index":0,"n_rows":139,"n_cols":38,"rows_kept":139,"cut":false,"hidden":false,"merged":[[101,36,101,40],[102,36,102,42],[14,31,14,32],[15,1,15,28],[19,1,19,28],[20,1,21,28],[18,7,18,25],[32,2,32,3],[30,1,30,28],[32,4,32,28],[31,1,31,28],[22,1,22,28],[30,31,30,33],[37,14,37,20],[37,21,37,28],[40,2,40,3],[38,1,38,28],[69,1,69,28],[40,5,40,6],[40,7,40,25],[39,2,39,3],[39,5,39,6],[39,7,39,28],[1,1,1,28],[16,5,16,6],[16,7,16,28],[6,18,6,25],[7,1,7,4],[4,1,4,28],[5,1,5,28],[2,1,2,28],[6,1,6,4],[6,5,6,13],[7,17,7,18],[16,2,16,3],[7,5,7,6],[6,14,6,17],[7,11,7,12],[7,7,7,10],[7,13,7,16],[7,19,7,25],[8,1,8,25],[11,1,11,28],[3,1,3,28],[6,28,8,28],[6,26,8,26],[6,27,8,27],[100,2,100,3],[101,1,101,28],[72,1,72,28],[73,1,73,28],[100,4,100,25],[75,28,76,28],[93,1,93,28],[94,1,94,28],[80,4,80,28],[97,1,97,28],[99,1,99,28],[81,4,81,25],[82,4,82,25],[83,4,83,25],[98,1,98,28],[76,2,76,3],[96,4,96,25],[81,2,81,3],[82,2,82,3],[83,2,83,3],[84,2,84,3],[85,2,85,3],[96,2,96,3],[77,1,77,28],[95,1,95,28],[26,2,26,3],[94,31,94,32],[94,34,94,35],[96,31,96,32],[96,34,96,35],[24,7,24,28],[28,7,28,25],[86,2,86,3],[86,4,86,25],[81,28,86,28],[24,2,24,3],[25,7,25,25],[27,2,27,3],[27,5,27,6],[27,7,27,25],[33,2,33,3],[34,1,34,28],[33,4,33,25],[29,1,29,28],[70,1,70,28],[78,1,78,28],[79,1,79,28],[80,2,80,3],[94,36,94,39],[4,30,4,32],[5,30,5,35],[6,30,6,31],[14,5,14,11],[14,13,14,18],[14,19,14,28],[10,1,10,28],[12,1,13,28],[17,7,17,25],[18,2,18,3],[18,5,18,6],[84,4,84,25],[85,4,85,25],[17,2,17,3],[17,5,17,6],[26,5,26,6],[26,7,26,25],[28,5,28,6],[23,1,23,28],[20,30,21,30],[20,31,21,32],[22,31,22,32],[12,31,12,32],[9,1,9,28],[41,2,41,3],[41,5,41,6],[41,7,41,25],[14,1,14,3],[87,1,87,28],[66,18,66,25],[66,26,68,26],[66,27,68,27],[66,28,68,28],[74,2,74,3],[75,2,75,3],[75,4,75,25],[76,4,76,25],[71,1,71,28],[74,4,74,28],[25,2,25,3],[24,5,24,6],[25,5,25,6],[28,2,28,3],[35,1,35,28],[36,1,36,28],[37,1,37,3],[37,5,37,12],[88,1,88,28],[89,1,89,28],[90,2,90,3],[91,2,91,3],[92,2,92,3],[91,4,91,25],[92,4,92,25],[90,4,90,28],[61,1,61,28],[62,1,62,28],[63,1,63,28],[64,1,64,28],[65,1,65,28],[68,1,68,25],[66,1,66,4],[67,1,67,4],[66,5,66,13],[67,5,67,6],[67,7,67,10],[67,11,67,12],[67,13,67,16],[67,17,67,18],[67,19,67,25],[66,14,66,17]]}
[]
[]
[]
[null,"BILL OF MATERIALS"]
[null,{"$f":"AE5&AK6&AE6","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"Flat Single Face Body\",IF(BodyType=2,\"Flat Double Face Medium Body\",IF(BodyType=3,\"Flat Double Face Body\",IF(BodyType=4,\"Flat 2 Piece Double Face Medium Body\",IF(BodyType=5,\"Flat 2 Piece Double Face Body\",IF(BodyType=6,\"Flat Retro Body\",IF(BodyType=7,\"Flat Wall Mount Retro Body\",\"\")))))))))","v":""}]
[null,{"$f":"AE7","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType=1,\" 1-1/2'' Retainer\",IF(RetType=2,\" 2'' Retainer\",IF(RetType=3,\" Flat Bleed Rigid Retainer\",IF(RetType=4,\" Flat Bleed Retro Frame and Flat Bleed Retro Frame Cover\",IF(RetType=5,\" Flat Bleed Retro Frame II and Flat Bleed Retro Frame Cover\")))))))","v":""},null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(RET=1,\"\",IF(RetType=1,\" with\",IF(RetType=2,\" with\",IF(RetType=3,\" with\",IF(RetType=4,\" with\",IF(RetType=5,\" with\"))))))))","v":""}]
[null,"Customer  ",null,null,null,null,null,null,null,null,null,null,null,null,"Order #",null,null,null,null,null,null,null,null,null,null,null,"Lengths Required","Lengths Used","Drops Used",null,{"$f":"IF(KQ=0,\"\",\"Mill Finish\")","v":""}]
[null,"Kit Quantity  ",null,null,null,0,null,"Height  ",null,null,null,0,null,"Width",null,null,null,0,null,"Enter Fractions as Decimals"]
[null,"Add one inch (1'') the direction of the lamp when fluorescent lamps are to be used for illumination."]
[]
[null,"Extrusions"]
[]
[null,"Body Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Flat Bodies",null,1,"Bodies"]
[]
[null,"Body",null,null,null,{"$f":"IF(KQ=0,\"\",IF(BodyType=6,\"Retro Body Standard Add-on\",\"\"))","v":""},null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(BodyType=6,\"Retro Body No Add-on\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Retro Add-on"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=3),KQ*2,IF(OR(BodyType=4,BodyType=5),KQ*4,IF(OR(BodyType=6,BodyType=7),KQ*2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=3),Hgt,IF(OR(BodyType=4,BodyType=5),Hgt,IF(AND(BodyType=6,AE15=1),Hgt+0.325,IF(AND(BodyType=6,AE15=2),Hgt+0.2,IF(BodyType=7,Hgt,\"\")))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"2027\",IF(BodyType=2,\"2007\",IF(BodyType=3,\"2008\",IF(BodyType=4,\"2010\",IF(BodyType=5,\"2009\",IF(BodyType=6,\"2041\",IF(BodyType=7,\"2042\",\"\")))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Flat Single Face Body - Sides - Mitered Both Ends \",IF(BodyType=2,\" Flat Double Face Medium Body - Sides - Mitered Both Ends\",IF(BodyType=3,\" Flat Double Face Body - Sides - Mitered Both Ends\",IF(BodyType=4,\" Flat 2 Piece Double Face Medium Body - Sides - Mitered Both Ends\",IF(BodyType=5,\" Flat 2 Piece Double Face Body - Sides - Mitered Both Ends\",IF(BodyType=6,\" Flat Retro Body - Sides - Mitered Both Ends\",IF(BodyType=7,\" Flat Wall Mount Retro Body - Sides - Mitered Both Ends\",\"\")))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=3),KQ*2,IF(OR(BodyType=4,BodyType=5),KQ*4,IF(OR(BodyType=6,BodyType=7),KQ*2,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=3),Wdt,IF(OR(BodyType=4,BodyType=5),Wdt,IF(AND(BodyType=6,RetroADD=1),Wdt+0.325,IF(AND(BodyType=6,RetroADD=2),Wdt+0.2,IF(BodyType=7,Wdt,\"\")))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"2027\",IF(BodyType=2,\"2007\",IF(BodyType=3,\"2008\",IF(BodyType=4,\"2010\",IF(BodyType=5,\"2009\",IF(BodyType=6,\"2041\",IF(BodyType=7,\"2042\",\"\")))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Flat Single Face Body - Top and Bottom - Mitered Both Ends \",IF(BodyType=2,\" Flat Double Face Medium Body - Top and Bottom - Mitered Both Ends\",IF(BodyType=3,\" Flat Double Face Body - Top and Bottom - Mitered Both Ends\",IF(BodyType=4,\" Flat 2 Piece Double Face Medium Body - Top and Bottom - Mitered Both Ends\",IF(BodyType=5,\" Flat 2 Piece Double Face Body - Top and Bottom - Mitered Both Ends\",IF(BodyType=6,\" Flat Retro Body - Top and Bottom - Mitered Both Ends\",IF(BodyType=7,\" Flat Wall Mount Retro Body - Top and Bottom - Mitered Both Ends\",\"\")))))))))","v":""}]
[]
[null,"Retainer Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Retainers"]
[]
[null,"Retainer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Retainers"]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"  Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(OR(OR(BodyType=1,BodyType=6,BodyType=7))),KQ*2,IF(OR(BodyType>=2,BodyType<=5),KQ*4,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(BodyType=6,RetroADD=1),Hgt+0.325,IF(AND(BodyType=6,RetroADD=2),Hgt+0.2,IF(AND(RetType>=1,RetType<=5),Hgt,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType=1,\"2052\",IF(RetType=2,\"2047\",IF(RetType=3,\"2204\",IF(RetType=4,\"2104\",IF(RetType=5,\"2107\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType=1,\" 1-1/2'' Retainer - Sides - Mitered Both Ends\",IF(RetType=2,\" 2'' Retainer - Sides - Mitered Both Ends\",IF(RetType=3,\" Flat Bleed Rigid Retainer - Sides - Mitered Both Ends\",IF(RetType=4,\" Flat Bleed Retro Frame - Sides - Mitered Both Ends\",IF(RetType=5,\" Flat Bleed Retro Frame II - Sides - Mitered Both Ends\",\"\")))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(AND(OR(OR(BodyType=1,BodyType=6,BodyType=7))),KQ*2,IF(OR(BodyType>=2,BodyType<=5),KQ*4,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(AND(BodyType=6,RetroADD=1),Hgt+0.325,IF(AND(BodyType=6,RetroADD=2),Hgt+0.2,IF(RetType=4,Hgt,IF(RetType=5,Hgt,\"\")))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(RetType=4,\"2121\",IF(RetType=5,\"2121\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(RetType=4,\" Flat Bleed Retro Frame Cover - Sides - Mitered Both Ends\",IF(RetType=5,\" Flat Bleed Retro Frame Cover - Sides - Mitered Both Ends\",\"\")))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(OR(OR(BodyType=1,BodyType=6,BodyType=7))),KQ*2,IF(OR(BodyType>=2,BodyType<=5),KQ*4,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(BodyType=6,RetroADD=1),Wdt+0.325,IF(AND(BodyType=6,RetroADD=2),Wdt+0.2,IF(AND(RetType>=1,RetType<=5),Wdt,\"\")))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType=1,\"2052\",IF(RetType=2,\"2047\",IF(RetType=3,\"2204\",IF(RetType=4,\"2104\",IF(RetType=5,\"2107\",\"\")))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType=1,\" 1-1/2'' Retainer - Top and Bottom - Mitered Both Ends\",IF(RetType=2,\" 2'' Retainer - Top and Bottom - Mitered Both Ends\",IF(RetType=3,\" Flat Bleed Rigid Retainer - Top and Bottom - Mitered Both Ends\",IF(RetType=4,\" Flat Bleed Retro Frame - Top and Bottom - Mitered Both Ends\",IF(RetType=5,\" Flat Bleed Retro Frame II - Top and Bottom - Mitered Both Ends\",\"\")))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(AND(OR(OR(BodyType=1,BodyType=6,BodyType=7))),KQ*2,IF(OR(BodyType>=2,BodyType<=5),KQ*4,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(AND(BodyType=6,RetroADD=1),Wdt+0.325,IF(AND(BodyType=6,RetroADD=2),Wdt+0.2,IF(RetType=4,Wdt,IF(RetType=5,Wdt,\"\")))))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(RetType=4,\"2121\",IF(RetType=5,\"2121\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(RetType=4,\" Flat Bleed Retro Frame Cover - Sides - Mitered Both Ends\",IF(RetType=5,\" Flat Bleed Retro Frame Cover - Sides - Mitered Both Ends\",\"\")))))","v":""}]
[]
[null,"Frame Support Tube",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Frame Suppot Tube"]
[]
[null,"Qty.","Part #",null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Height","FST Horz","Width","FST Vert","FSTH (In)","FSTV (In)","FSTReq SF","FSTReq DF"]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(FST=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(AND(BodyType=1,FBTYP=4),\"\",IF(AND(BodyType=2,FBTYP=2),\"\",IF(AND(RetType=4,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),FSTLngthsSF*KQ,IF(AND(RetType=4,OR(BodyType>=2,BodyType<=5)),FSTLngthsDF*KQ,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(FST=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(AND(BodyType=1,FBTYP=4),\"\",IF(AND(BodyType=2,FBTYP=2),\"\",IF(FBTYP=1,\"2175\",IF(FBTYP=2,\"2175\",IF(FBTYP=3,\"2177\",IF(FBTYP=4,\"2177\",\"\"))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(FST=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(AND(BodyType=1,FBTYP=4),\" Retro Frame Brace Is Not For Use With Single Face Body\",IF(AND(BodyType=2,FBTYP=2),\" 2 Piece Frame Brace Is Not For Use With Flat Medium Double Face Body\",IF(FBTYP=1,\" Frame Support Tube - 3/4'' x 1-5/8'' Rectangular Aluminum Tube - (24'-0'' lengths)\",IF(FBTYP=2,\" Frame Support Tube - 3/4'' x 1-5/8'' Rectangular Aluminum Tube - (24'-0'' lengths)\",IF(FBTYP=3,\" Small Frame Support Tube - 1'' x 1'' Sq. Aluminum Tube - (24'-0'' lengths)\",IF(FBTYP=4,\" Small Frame Support Tube - 1'' x 1'' Sq. Aluminum Tube - (24'-0'' lengths)\",\"\"))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Hgt","v":0},{"$f":"IF(CHgt<=71,0,ROUNDDOWN(CHgt/37,0))","v":0},{"$f":"Wdt","v":0},{"$f":"IF(CWdth<=71,0,ROUNDDOWN(CWdth/37,0))","v":0},{"$f":"CWdth*NumFSTH","v":0},{"$f":"CHgt*NumFTSV","v":0},{"$f":"ROUNDUP((((FSTHTIn+FSTVTIn)/12)/24),0)","v":0},{"$f":"ROUNDUP(((((FSTHTIn+FSTVTIn)*2)/12)/24),0)","v":0}]
[]
[null,"Divider",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Divider Type",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,false,false]
[null,null,null,null,0,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(Horz=FALSE,\"\",IF(Horz=TRUE,\"  Insert Number of Horizontal Divider(s),\",\"\"))))","v":""},null,null,null,null,null,null,null,0,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(Vert=FALSE,\"\",IF(Vert=TRUE,\"  Insert Number of Vertical Divider(s),\",\"\"))))","v":""}]
[]
[null,"Qty.","Size (in)",null,"x","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(Horz=TRUE,BodyType=1),HDivider*KQ,IF(AND(Horz=TRUE,BodyType=2),HDivider*2*KQ,IF(AND(Horz=TRUE,BodyType=3),HDivider*2*KQ,IF(AND(Horz=TRUE,BodyType=4),HDivider*2*KQ,IF(AND(Horz=TRUE,BodyType=5),HDivider*2*KQ,IF(AND(Horz=TRUE,BodyType=6),HDivider*KQ,IF(AND(Horz=TRUE,BodyType=7),HDivider*KQ,\"\")))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(RetType=1,Horz=TRUE),Wdt-3,IF(AND(RetType=2,Horz=TRUE),Wdt-4,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(Horz=TRUE,\"2130\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(Horz=TRUE,\"  Flat Divider - Horizontal - Straight Cut Both Ends\",\"\")))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(Vert=TRUE,BodyType=1),VDivider*KQ,IF(AND(Vert=TRUE,BodyType=2),VDivider*2*KQ,IF(AND(Vert=TRUE,BodyType=3),VDivider*2*KQ,IF(AND(Vert=TRUE,BodyType=4),VDivider*2*KQ,IF(AND(Vert=TRUE,BodyType=5),VDivider*2*KQ,IF(AND(Vert=TRUE,BodyType=6),VDivider*KQ,IF(AND(Vert=TRUE,BodyType=7),VDivider*KQ,\"\")))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(RetType=1,Vert=TRUE),Hgt-3,IF(AND(RetType=2,Vert=TRUE),Hgt-4,\"\"))))","v":""},null,null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(Vert=TRUE,\"2130\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(Vert=TRUE,\"  Flat Divider - Vertical - Straight Cut Both Ends\",\"\")))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"BILL OF MATERIALS"]
[null,{"$f":"AE5&AK6&AE6","v":""}]
[null,{"$f":"AE7","v":""}]
[null,"Customer  ",null,null,null,{"$f":"Cust","v":0},null,null,null,null,null,null,null,null,"Order #",null,null,null,{"$f":"Ordnum","v":0},null,null,null,null,null,null,null,"Lengths Required","Lengths Used","Drops Used"]
[null,"Kit Quantity  ",null,null,null,{"$f":"KQ","v":0},null,"Height  ",null,null,null,{"$f":"Hgt","v":0},null,"Width",null,null,null,{"$f":"Wdt","v":0},null,"Enter Fractions as Decimals"]
[null,"Add one inch (1'') the direction of the lamp when fluorescent lamps are to be used for illumination."]
[]
[null,"Hardware"]
[]
[null,"Body"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(AND(BodyType>=1,BodyType<=3),KQ*4,IF(OR(BodyType=4,BodyType=5),KQ*4,IF(OR(BodyType=6,BodyType=7),KQ*4,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"5327\",IF(BodyType=2,\"5907\",IF(BodyType=3,\"5908\",IF(BodyType=4,\"5910\",IF(BodyType=5,\"5909\",IF(BodyType=6,\"5305\",IF(BodyType=7,\"5305\",\"\")))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Flat Single Face Body Corner Angle - One (1) Per Corner - 2-1/2'' x 2-1/2'' x 1/4'' (5-5/8'')\",IF(BodyType=2,\" Flat Double Face Medium Body Corner Angle - One (1) Per Corner - 2-1/2'' x 2-1/2'' x 1/4'' (3-13/16'')\",IF(BodyType=3,\" Flat Double Face Body Corner Angle - One (1) Per Corner - 2-1/2'' x 2-1/2'' x 1/4'' (8-9/16'')\",IF(BodyType=4,\" Flat 2 Piece Double Face Medium Body Corner Angle - One (1) Per Corner - 2-1/2'' x 2-1/2'' x 1/4'' (11-9/16'')\",IF(BodyType=5,\" Flat 2 Piece Double Face Body Corner Angle - One (1) Per Corner - (2-1/2'' x 2-1/2'' x 1/4'' (15-9/16'')\",IF(BodyType=6,\" Flat Retro Body Corner Angle - One (1) Per Corner - 1-3/4'' x 1-3/4'' x 1/4'' (1-1/16'')\",IF(BodyType=7,\" Flat Wall Mount Retro Body Corner Angle - One (1) Per Corner - 1-3/4'' x 1-3/4'' x 1/4'' (1-1/16'')\",\"\")))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,34*KQ,IF(OR(BodyType=2,BodyType=3),18*KQ,IF(OR(BodyType=4,BodyType=5),18*KQ,IF(OR(BodyType=6,BodyType=7),10*KQ,\"\"))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\"5199\",IF(OR(BodyType=2,BodyType=3),\"5218\",IF(OR(BodyType=4,BodyType=5),\"5218\",IF(OR(BodyType=6,BodyType=7),\"5218\",\"\"))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(BOD=1,\"\",IF(BodyType=1,\" Body Corner Angle Screw - #8 x 3/8'' steel zinc sq/phillips drive pan head screw - Type B - Eight (8) Per Corner\",IF(OR(BodyType=2,BodyType=3),\" Body Corner Angle Screw - #10 x 1/2'' SS sq/phillips dirve pan head tapping screw w/wax - Type AB - Four (4) Per Corner\",IF(OR(BodyType=4,BodyType=5),\" Body Corner Angle Screw - #10 x 1/2'' SS sq/phillips dirve pan head tapping screw w/wax - Type AB - Four (4) Per Corner\",IF(OR(BodyType=6,BodyType=7),\" Body Corner Angle Screw - #10 x 1/2'' SS sq/phillips dirve pan head tapping screw w/wax - Type AB - Two (2) Per Corner\",\"\"))))))","v":""}]
[]
[null,"Retainer"]
[]
[null,"Qty.","Part#",null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hnge Scr","Height","Width","Height","Cls Scr"]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType=1,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*4,IF(AND(RetType=2,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*4,IF(AND(RetType=3,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*4,IF(AND(RetType=4,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*8,IF(AND(RetType=5,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*8,IF(AND(RetType=1,OR(BodyType>=2,BodyType<=5)),KQ*8,IF(AND(RetType=2,OR(BodyType>=2,BodyType<=5)),KQ*8,IF(AND(RetType=3,OR(BodyType>=2,BodyType<=5)),KQ*8,IF(AND(RetType=4,OR(BodyType>=2,BodyType<=5)),KQ*16,IF(AND(RetType=5,OR(BodyType>=2,BodyType<=5)),KQ*16,\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType=1,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5213\",IF(AND(RetType=2,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5214\",IF(AND(RetType=3,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5210\",IF(AND(RetType=4,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5305\",IF(AND(RetType=5,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5305\",IF(AND(RetType=1,OR(BodyType>=2,BodyType<=5)),\"5213\",IF(AND(RetType=2,OR(BodyType>=2,BodyType<=5)),\"5214\",IF(AND(RetType=3,OR(BodyType>=2,BodyType<=5)),\"5210\",IF(AND(RetType=4,OR(BodyType>=2,BodyType<=5)),\"5305\",IF(AND(RetType=5,OR(BodyType>=2,BodyType<=5)),\"5305\",\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType=1,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" 1-1/2''/38.1mm Frame Corner Bracket - One (1) Set Per Corner\",IF(AND(RetType=2,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" 2''/50.8mm Frame Corner Bracket - One (1) Set Per Corner\",IF(AND(RetType=3,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" Corner Key - .120 stamped aluminum - One (1) Per Corner\",IF(AND(RetType=4,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" Frame Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' - 1-1/16'' aluminum angle - Two (2) Per Corner\",IF(AND(RetType=5,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" Frame Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' - 1-1/16'' aluminum angle - Two (2) Per Corner\",IF(AND(RetType=1,OR(BodyType>=2,BodyType<=5)),\" 1-1/2''/38.1mm Frame Corner Bracket - One (1) Set Per Corner\",IF(AND(RetType=2,OR(BodyType>=2,BodyType<=5)),\" 2''/50.8mm Frame Corner Bracket - One (1) Set Per Corner\",IF(AND(RetType=3,OR(BodyType>=2,BodyType<=5)),\" Corner Key - .120 stamped aluminum - One (1) Per Corner\",IF(AND(RetType=4,OR(BodyType>=2,BodyType<=5)),\" Frame Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' - 1-1/16'' aluminum angle - Two (2) Per Corner\",IF(AND(RetType=5,OR(BodyType>=2,BodyType<=5)),\" Frame Corner Angle - 1-3/4'' x 1-3/4'' x 1/4'' - 1-1/16'' aluminum angle - Two (2) Per Corner\",\"\"))))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP((Wdt/18)+1,0)","v":1},{"$f":"ROUNDUP((Hgt/36)+1,0)","v":1},{"$f":"ROUNDUP((Wdt/36)+1,0)","v":1},{"$f":"ROUNDUP((Hgt/36)+1,0)","v":1},{"$f":"SUM(AF82:AH82)","v":3}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType=1,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*18,IF(AND(RetType=2,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*18,IF(AND(RetType=3,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*18,IF(AND(RetType=4,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*10,IF(AND(RetType=5,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),KQ*10,IF(AND(RetType=1,OR(BodyType>=2,BodyType<=5)),KQ*34,IF(AND(RetType=2,OR(BodyType>=2,BodyType<=5)),KQ*34,IF(AND(RetType=3,OR(BodyType>=2,BodyType<=5)),KQ*34,IF(AND(RetType=4,OR(BodyType>=2,BodyType<=5)),KQ*18,IF(AND(RetType=5,OR(BodyType>=2,BodyType<=5)),KQ*18,\"\"))))))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType=1,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5195\",IF(AND(RetType=2,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5195\",IF(AND(RetType=3,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5168\",IF(AND(RetType=4,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5218\",IF(AND(RetType=5,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\"5218\",IF(AND(RetType=1,OR(BodyType>=2,BodyType<=5)),\"5195\",IF(AND(RetType=2,OR(BodyType>=2,BodyType<=5)),\"5195\",IF(AND(RetType=3,OR(BodyType>=2,BodyType<=5)),\"5168\",IF(AND(RetType=4,OR(BodyType>=2,BodyType<=5)),\"5218\",IF(AND(RetType=5,OR(BodyType>=2,BodyType<=5)),\"5218\",\"\"))))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType=1,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" Corner Bracket Screw - #8 x 5/16'' steel zinc sq/phillips drive pan head screw - Type B - Four (4) Per Corner\",IF(AND(RetType=2,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" Corner Bracket Screw - #8 x 5/16'' steel zinc sq/phillips drive pan head screw - Type B - Four (4) Per Corner\",IF(AND(RetType=3,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" Frame Corner Key Screw - #8 x 1/2'' SS sq/phillips drive countersink screw - Type A - Four (4) Per Corner\",IF(AND(RetType=4,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" Frame Corner Angle Screw - #10 x1/2'' SS sq/phillips pan head tapping screw w/wax - Type AB - Two (2) Per Corner\",IF(AND(RetType=5,OR(OR(OR(BodyType=1,BodyType=6,BodyType=7)))),\" Frame Corner Angle Screw - #10 x1/2'' SS sq/phillips pan head tapping screw w/wax - Type AB - Two (2) Per Corner\",IF(AND(RetType=1,OR(BodyType>=2,BodyType<=5)),\" Corner Bracket Screw - #8 x 5/16'' steel zinc sq/phillips drive pan head screw - Type B - Four (4) Per Corner\",IF(AND(RetType=2,OR(BodyType>=2,BodyType<=5)),\" Corner Bracket Screw - #8 x 5/16'' steel zinc sq/phillips drive pan head screw - Type B - Four (4) Per Corner\",IF(AND(RetType=3,OR(BodyType>=2,BodyType<=5)),\" Frame Corner Key Screw - #8 x 1/2'' SS sq/phillips drive countersink screw - Type A - Four (4) Per Corner\",IF(AND(RetType=4,OR(BodyType>=2,BodyType<=5)),\" Frame Corner Angle Screw - #10 x1/2'' SS sq/phillips pan head tapping screw w/wax - Type AB - Two (2) Per Corner\",IF(AND(RetType=5,OR(BodyType>=2,BodyType<=5)),\" Frame Corner Angle Screw - #10 x1/2'' SS sq/phillips pan head tapping screw w/wax - Type AB - Two (2) Per Corner\",\"\"))))))))))))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(AND(OR(OR(BodyType=1,BodyType=6,BodyType=7))),(CVRSCR+2)*KQ,IF(OR(BodyType>=2,BodyType<=5),((CVRSCR*2)+2)*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(RetType=4,\"5195\",IF(RetType=5,\"5195\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(RetType=4,\" Cover Screw - #8 x 5/16'' steel zinc sq/phillips drive pan head screw - Type B - One (1) every 24'' on center\",IF(RetType=5,\" Cover Screw - #8 x 5/16'' steel zinc sq/phillips drive pan head screw - Type B - One (1) every 24'' on center\",\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Height","Width","Height","Width","Cvr Scrs"]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(OR(OR(BodyType=1,BodyType=6,BodyType=7))),(HNGSCR+2)*KQ,IF(OR(BodyType>=2,BodyType<=5),((HNGSCR*2)+2)*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=5),5178,\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=5),\" Hinge Screw - #10 x 5/8'' steel zinc sq/phillips drive flat head screw - Type B - One (1) every 18'' on center\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP((Hgt/24)+1,0)","v":1},{"$f":"ROUNDUP((Wdt/24)+1,0)","v":1},{"$f":"ROUNDUP((Hgt/24)+1,0)","v":1},{"$f":"ROUNDUP((Wdt/24)+1,0)","v":1},{"$f":"SUM(AE85:AH85)","v":4}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(OR(OR(BodyType=1,BodyType=6,BodyType=7))),(CLSSCR+2)*KQ,IF(OR(BodyType>=2,BodyType<=5),((CLSSCR*2)+2)*KQ,\"\"))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=5),5178,\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(AND(RetType>=1,RetType<=5),\" Closure Screw - #10 x 5/8'' steel zinc sq/phillips drive flat head screw - Type B - One (1) every 36'' on center\",\"\")))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType=3,FCEBLT*KQ,\"\")))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType=3,\"5285\",\"\")))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType=3,\" Face Attachment Hardware - 1/4-20 x 1'' CS Machine Screw/Bushing /Nut - One (1) every 12'' on Center\",\"\")))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(RetType=3,ROUNDUP((Hgt/12),0),ROUNDDOWN((Hgt/24)+1,0))","v":1},{"$f":"IF(RetType=3,ROUNDUP((Wdt/12),0),ROUNDDOWN((Wdt/24)+1,0))","v":1},{"$f":"IF(RetType=3,ROUNDUP((Hgt/12),0),ROUNDDOWN((Hgt/24)+1,0))","v":1},{"$f":"IF(RetType=3,ROUNDUP((Wdt/12),0),ROUNDDOWN((Wdt/24)+1,0))","v":1},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=2,\"\",IF(AND(BodyType=1,RetType=3),SUM(AE87:AH87)+2,IF(AND(AND(BodyType>=2,BodyType<=5,RetType=3)),SUM(AE87:AH87)*2+2,IF(AND(BodyType>=6,RetType=3),SUM(AE87:AH87)+2,IF(RetType=4,\"\",\"\")))))))","v":""}]
[]
[null,"Divider"]
[]
[null,"Qty.","Part #",null,"Description"]
[null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(BodyType=1,BKTT,IF(BodyType=2,BKTT*2,IF(BodyType=3,BKTT*2,IF(BodyType=4,BKTT*2,IF(BodyType=5,BKTT*2,IF(BodyType=6,BKTT,IF(BodyType=7,BKTT,\"\")))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(Horz=TRUE,Vert=FALSE),\"5302\",IF(AND(Horz=FALSE,Vert=TRUE),\"5302\",IF(AND(Horz=TRUE,Vert=TRUE),\"5302\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(Horz=TRUE,Vert=FALSE),\" Flat Divider Mounting Bracket - Horizontal - One (1) each end\",IF(AND(Horz=FALSE,Vert=TRUE),\" Flat Divder Mounting Bracket - Vertical - One (1) each end\",IF(AND(Horz=TRUE,Vert=TRUE),\" Flat Divider Mounting Bracket - Horizontal and Vertical - One (1) end of each section of divider\",\"\")))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(Horz=FALSE,Vert=TRUE),\"0\",IF(Horz=TRUE,HDivider*2))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(Horz=TRUE,Vert=FALSE),\"0\",IF(AND(Horz=FALSE,Vert=TRUE),VDivider*2,IF(AND(Horz=TRUE,Vert=TRUE),VDivider*2+(HDivider*2),\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",(HBKT+VBKT)*KQ))","v":""}]
[null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",((B92*2)+(KQ*2))))","v":""},{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(Horz=TRUE,Vert=FALSE),\"5290\",IF(AND(Horz=FALSE,Vert=TRUE),\"5290\",IF(AND(Horz=TRUE,Vert=TRUE),\"5290\",\"\")))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(Divider=1,\"\",IF(AND(Horz=TRUE,Vert=FALSE),\" Flat Divider Mounting Bracket Screw - Horizontal - Two (2) each end\",IF(AND(Horz=FALSE,Vert=TRUE),\" Flat Divder Mounting Bracket Screw - Vertical - Two (2) each end\",IF(AND(Horz=TRUE,Vert=TRUE),\" Flat Divider Mounting Bracket Screw - Horizontal and Vertical - Two (2) end of each section of divider\",\"\")))))","v":""}]
[]
[null,"Frame Braces",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Frame Braces N/Y",null,1,"Frame Braces"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(YESNO=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(AND(BodyType=1,FBTYP=4),\"\",IF(AND(BodyType=2,FBTYP=2),\"\",IF(AND(AND(BodyType=7,RetType>=4,FBTYP>=1)),((VFB+HFB)*2)*KQ,IF(AND(AND(RetType>=4,FBTYP>=1,OR(BodyType=1,BodyType=6))),(VFB+HFB)*KQ,IF(AND(AND(RetType>=4,FBTYP>=1,BodyType>=2,BodyType<=5)),((VFB+HFB)*2)*KQ,\"\"))))))))","v":""},{"$f":"IF(KQ=0,\"\",IF(YESNO=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(AND(BodyType=1,FBTYP=4),\"\",IF(AND(BodyType=2,FBTYP=2),\"\",IF(BodyType=7,\"5300\",IF(FBTYP=1,\"5350\",IF(FBTYP=2,\"5357\",IF(FBTYP=3,\"5352\",IF(FBTYP=4,\"5354\",\"\"))))))))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(YESNO=1,\"\",IF(AND(RetType>=1,RetType<=3),\"\",IF(AND(BodyType=1,FBTYP=4),\" Retro Frame Brace Is Not For Use With Single Face Body\",IF(AND(BodyType=2,FBTYP=2),\" 2 Piece Frame Brace Is Not For Use With Flat Medium Double Face Body\",IF(BodyType=7,\" Divider Corner Angle w/Notch - 1-3/4'' x 1-3/4'' x 1/4'' x 1-1/16'' - Two (2) Approx. Every 36'' on Center\",IF(FBTYP=1,\" Frame Brace - 1-3/8'' Wide - Approx. Every 36'' on Center\",IF(FBTYP=2,\" 2 Piece Frame Brace - 1'' Wide - Approx. Every 36'' on Center\",IF(FBTYP=3,\" Small Frame Brace - 1-1/8'' Wide - Approx. Every 36'' on Center\",IF(FBTYP=4,\" Retro Frame Brace - 1-1/8'' Wide - Approx. Every 36'' on Center\",\"\"))))))))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NumFTSV*2","v":0},"Vert Braces",null,{"$f":"NumFSTH*2","v":0},"Horz Braces"]
[]
[null,"Tension Clips",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Height","Width","Height","Width","Total Clips"]
[]
[null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(AND(RetType>=4,OR(BodyType=1,BodyType=6,BodyType=7)),TENCLIPS*KQ,IF(AND(RetType>=4,OR(BodyType=2,BodyType=3,BodyType=4,BodyType=5)),TENCLIPS*2*KQ,\"\")))))","v":""},{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,\"5360\",\"\"))))","v":""},null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,\" Tension Clip - One (1) every 5'' on center along the top, bottom and sides\",\"\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP((Hgt/5)+1,0)","v":1},{"$f":"ROUNDUP((Wdt/5)+1,0)","v":1},{"$f":"ROUNDUP((Hgt/5)+1,0)","v":1},{"$f":"ROUNDUP((Wdt/5)+1,0)","v":1},{"$f":"SUM(AE101:AH101)","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Retro Frame Brace Is Not For Use With Single Face Body"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 2 Piece Frame Brace Is Not For Use With Flat Medium Double Face Body"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Flex Face Dimensions","index":1,"n_rows":58,"n_cols":31,"rows_kept":58,"cut":false,"hidden":false,"merged":[[54,1,54,28],[55,7,55,12],[55,13,55,14],[55,15,55,24],[57,7,57,12],[57,13,57,14],[57,15,57,26],[34,1,34,28],[35,1,35,28],[52,1,52,28],[53,8,53,12],[53,13,53,14],[53,15,53,24],[33,1,33,28],[30,3,30,9],[30,10,30,11],[30,13,30,19],[30,20,30,21],[30,22,30,28],[31,1,31,28],[32,3,32,9],[32,10,32,11],[32,13,32,19],[32,20,32,21],[32,22,32,28],[29,1,29,28],[8,1,8,28],[25,1,25,28],[26,1,26,4],[26,5,26,21],[26,22,26,28],[27,1,27,28],[28,3,28,9],[28,10,28,11],[28,13,28,19],[28,20,28,21],[28,22,28,28],[7,1,7,28],[1,1,1,28],[2,1,2,28],[3,1,3,28],[4,1,5,28],[6,1,6,28]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Face Trim Size Calculations"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Frame Type:",null,null,null,{"$f":"IF(KQ=0,\"\",IF(AND(Body=1,Cover=1),\" 2'' Retro Frame and 2=3/8'' Retro Frame Cover\",IF(AND(Body=2,Cover=2),\" Bleed Retro Frame and Bleed Retro Frame Cover\",IF(AND(Body=3,Cover=3),\" Flat Bleed Retro Frame and Flat Bleed Retro Frame Cover\",IF(AND(Body=3,Cover=4),\" Flat Bleed Retro Frame and Extended Flat Bleed Retro Frame Cover\",IF(AND(Body=3,Cover=5),\" Flat Bleed Retro Frame and 1-1/2'' Flat Bleed Retro Frame Cover\",IF(AND(Body=4,Cover=6),\" Wall Mount Tension Frame and Wall Mount Tension Frame Radius Cover\",IF(AND(Body=4,Cover=7),\" Wall Mount Tension Frame and Wall Mount Tension Frame Square Cover\",IF(AND(Body=4,Cover=8),\" Wall Mount Tension Frame and Wall Mount Tension Frame Beveled Cover\",\"\")))))))))","v":""}]
[]
[null,null,null,"Outside Frame dimension (Height) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,Hgt,\"\"))))","v":""},null,null,"Outside Frame Dimension (Width) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,Wdt,\"\"))))","v":""}]
[]
[null,null,null,"Visual Opening (Height) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,Hgt-0.184,\"\"))))","v":""},null,null,"Visual Opening (Width) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,Wdt-0.184,\"\"))))","v":""}]
[]
[null,null,null,"Face Trim Size (Height) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,Hgt+6.5,\"\"))))","v":""},null,null,"Face Trim Size (Width) ",null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,Wdt+6.5,\"\"))))","v":""}]
[]
[]
[null,"Clip Line Calculations"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Clip Line Placement ",null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,\"1-1/2''\",\"\"))))","v":""},null,"(In from the trimmed edge of the face.)"]
[]
[null,null,null,null,null,null,null,"Clip Spacing ",null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,\"5''\",\"\"))))","v":""},null,"(Center to Center)"]
[]
[null,null,null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType=4,\"Tensioning Tool \",\"\"))))","v":""},null,null,null,null,null,{"$f":"IF(KQ=0,\"\",IF(RET=1,\"\",IF(RetType<=3,\"\",IF(RetType>=4,\"5135\",\"\"))))","v":""},null,"(See Commercial Catalog Pg. 13 or Contact Customer Service)"]